Table - INCIDENT ANALYSIS

Model Table INCIDENT ANALYSIS

Attributes

Attribute Description (where applicable)
Incident Case Reference NoReference number of the incident to uniquely identify the incident
Injury/ Illness Reference NoSummary of the injured person is stored with the ref no 0 (zero) Refers to Injured Person section in the Incident Management page
Incident DateDate and time in which the incident occurred
Project IDIf the occurred incident is related to a project, the ID of the related project
Incident Case NoUniquely identifying Reference number of the incident
Incident ClassClassification of the incident
Incident TypeSub Classification of the incident
Incident Severity LevelSeverity level of the incident
Severity LevelSeverity level of the injury/illness that happened to the injured person
Reportable to External BodyIndicates whether the reported case should be reported to external regulatory body
Medical TreatmentInformation on Medical treatment obtained for the injury or illness
Personnel Incident Typeindicates whether the incident resulted with an Injury or illness
Loss of ConsciousnessIndicates whether the person has lost consciousness due to the incident
Injury/ Illness StatusStatus which identifies whether the injury and illness details registered for the employee have been confirmed in numerical format (Unconfirmed = 1/Confirmed = 2)
Personnel Injury/ Illness Status DescriptionStatus which identifies whether the injury and illness details registered for the employee have been confirmed in text format (Unconfirmed or Confirmed)

USED BY MODEL(S)

Model Name
Incident Analysis

Data source Information

The data source for this object is defined using IFS Developer Tool. The data source contains a number of transformations where the model reads data from the last step, i.e. the Data source view name (DW Source View Name).

Model Table DW Source view (SQL Server) BI Access View Referenced Information Source Recommended Access Type
INCIDENT ANALYSISFACT_INCIDENT_CASE_TMFACT_INCIDENT_CASE_BIFACT_INCIDENT_CASEOn Line